How to: Move a grouping section (when designing a report).
Solution:
In the Report Design view, select the 'View' menu and select 'Sorting and Grouping'. Press and hold down the mouse button over the record selector of the selected grouping field to its new location.
1) If the Database window is not active, activate the Database window.
2) Click the 'Reports' tab in the Database window.
Reports tab
3) Select the desired report from the list box. (The selected report is highlighted.)
4) Click 'Design'. (The selected report appears in the Design view, and the floating Toolbox appears.)
5) Select the 'View' menu and select 'Sorting and Grouping'. (The Sorting and Grouping dialog box appears.)
Grouping dialog box
6) Click record button corresponding to the group to be moved.
Selecting grouping record
7) Press and hold the field to its new location.
8) Release the mouse button. (The field is at its new location.)
9) Repeat steps 6) through 8) for each group to be moved.
10) Click on the 'X' in the upper right corner of the 'Sorting and Grouping' window to close.
11) Select the 'File' menu and select 'Save' to save the report.
